from sqlalchemy import Table, MetaData, Column, Integer, String, ForeignKey
from sqlalchemy.orm import registry
mapper_registry = registry()
Base = mapper_registry.generate_base()



class Project_logs(Base):
    __tablename__ = "project_logs"
    p_id = Column(String(32), primary_key=True)
    st_id = Column(String(32))
    p_name = Column(String(20))
    duty = Column(String(125))
    detail = Column(String(64))




    def __init__(self,p_id=None,st_id =None,p_name=None,duty=None,detail=None):
        self.p_id = p_id
        self.st_id = st_id
        self.p_name = p_name
        self.duty = duty
        self.detail = detail



    def format_str(self):
        return self.p_id+","+self.st_id+","+self.p_name+","+self.duty+","+self.detail











